SqlMap = {
    "list": "SELECT id,username,image_path,viewname FROM user where is_active>=1;",
    "info": "SELECT id,username,image_path,viewname FROM user limit 1;",
    "create": "INSERT INTO user (username,image_path,viewname)"
              " VALUES ('{username}','{image_path}','{viewname}');",
    "delete": "DELETE FROM user WHERE id = '{id}';",
    "edit": """UPDATE user SET username = '{username}',image_path = '{image_path}',viewname = '{viewname}' WHERE username = '{username}';""",
    "query":"SELECT * FROM user",
    "findbyid": "SELECT * FROM user where id={id} limit 1;",
    "save":"UPDATE user SET viewname='{viewname}',sex='{sex}',school_id='{school_id}',department='{department}',profession='{profession}',is_active='{is_active}' WHERE id = '{id}' or viewname='{viewname}'  "
}
